<?php

$installer = $this;

$installer->startSetup();

$installer->run("

DROP TABLE IF EXISTS {$this->getTable('autolinks')};
CREATE TABLE {$this->getTable('autolinks')} (
  `autolinks_id`     int(11) unsigned    NOT NULL auto_increment,

  `keyword`         varchar(255)        NOT NULL default '',
  `href`            varchar(1024)       NOT NULL default '',
  `priority`		int(10)				NOT NULL default '0',
  `status`          smallint(6)         NOT NULL default '0',
  `created_time`    datetime                NULL,
  `update_time`     datetime                NULL,

  PRIMARY KEY (`autolinks_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

    ");

$installer->endSetup(); 